UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wf0goVwqydOp7eJKfOf/EP7fSL7V7ZSganowGfZWHvE='
WHERE
key_id = '8e34c5228af8de1009572241877638d50624c12e9fb03a4f059f92379883b663'
AND (
token = 'wf0goVwqydOp7eJKfOf/EP7fSL7V7ZSganowGfZWHvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)