UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gccj2AM4ZCFe/2rBEFa+iPkJbIJBQPEhWAEZ9WnHOBE='
WHERE
key_id = '8b11137dc718aa285e60a51961ec587e465865a004d495765519792d4a210160'
AND (
token = 'gccj2AM4ZCFe/2rBEFa+iPkJbIJBQPEhWAEZ9WnHOBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)