UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+XBkJS75wKQjpcjHD1RoiYHAsLHvK9CZ8hQUrt1RA60='
WHERE
key_id = 'fd3f6ddbf2273b71f5fd707ef2a42387ccb973493a156192ed3340b8382478a7'
AND (
token = '+XBkJS75wKQjpcjHD1RoiYHAsLHvK9CZ8hQUrt1RA60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)