UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCXyvFhMIXz2NNJ516s4oOINSr+1s68AK6kOvN6tzYc='
WHERE
key_id = '6542f603bd11cbd76d2350e92440161841198cfe55628a092b5a692e2fe3e832'
AND (
token = 'YCXyvFhMIXz2NNJ516s4oOINSr+1s68AK6kOvN6tzYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)