UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6r7oITGMIGRhCzO+9Gm7/zipSSLxyyrb59VFA+EwzrM='
WHERE
key_id = 'fde7b8ad4ea74f7e7c3fba4dae5e8a15423f1498ceba9718b8d5befc1be09fac'
AND (
token = '6r7oITGMIGRhCzO+9Gm7/zipSSLxyyrb59VFA+EwzrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)