UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gmYf7/CNdmGBwKL/5KplSg9sDf/I63BxCWRVwBBKu0E='
WHERE
key_id = 'e851519545795c5fad6884e72ab60180e1e55bda457f2e45f04dc047cf66ae47'
AND (
token = 'gmYf7/CNdmGBwKL/5KplSg9sDf/I63BxCWRVwBBKu0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)