UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Dxniz0KgtmtsKMJFfppyY+zIEi/eQYyFBWfca65sZI='
WHERE
key_id = 'db6bfae1acf951f3d21135e59047924e8bf734cc16e6f70428c5cc5413d06a28'
AND (
token = '8Dxniz0KgtmtsKMJFfppyY+zIEi/eQYyFBWfca65sZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)