UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zy+ZDZxmWZ9tbA7w2kBV102aQOij07wI5bOBr13Rvlw='
WHERE
key_id = 'e6a24a4efe4051d00ee7356a8e7aa897af24d36b1a09c3f0312ae29cc343bb7f'
AND (
token = 'Zy+ZDZxmWZ9tbA7w2kBV102aQOij07wI5bOBr13Rvlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)