UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bSCGeCZcS1AycjX76ZCTMKFiA5PwENzD5sNXgBaAgns='
WHERE
key_id = '37e63f8c0e019e5ac30993c9ad0d35bb8d4a43878bd12e0aed29c4367c99244c'
AND (
token = 'bSCGeCZcS1AycjX76ZCTMKFiA5PwENzD5sNXgBaAgns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)