UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oS1jTWWt3+2Z1t4YRKPUPErP8XzuhRMgviXrM7Kk7bo='
WHERE
key_id = '3effcf14662b8a88daf9645eb1b00ea5f6389ad202e2da2525e5da9c3ede9780'
AND (
token = 'oS1jTWWt3+2Z1t4YRKPUPErP8XzuhRMgviXrM7Kk7bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)