UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcC7uPCEwWldXZ47tGQ//lJ72Y8dEUgSzfVDnopFbio='
WHERE
key_id = '09169475f45a2bc783d5a7d3c1271dd915058e5f9db71cf78da76ffbc7b348ec'
AND (
token = 'mcC7uPCEwWldXZ47tGQ//lJ72Y8dEUgSzfVDnopFbio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)