UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vV0i0dsn8fN5gwLUySCoYwKqRrzt9GnhIWJwyTbu4V4='
WHERE
key_id = '47787f4539947b75148ea9d91c698fdc597e016a424f052482acdf43e259506f'
AND (
token = 'vV0i0dsn8fN5gwLUySCoYwKqRrzt9GnhIWJwyTbu4V4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)