UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9M4SJfBMEWZOMVhk72vm+xIhd0Uc+HjsyidM1IpLst0='
WHERE
key_id = '27d751112d3d3a29c573c25c9fe43f031a130ce4bd30d1657c4a03b2ec968853'
AND (
token = '9M4SJfBMEWZOMVhk72vm+xIhd0Uc+HjsyidM1IpLst0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)