UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQiY2YhT3IpTmhwOqZPNguT9WXrmt0yS6cUbMCVGFTA='
WHERE
key_id = '49c5c9c83d6eff77b616cba6c99dff3ca679c25cdcdbb13c5598793fbdc33331'
AND (
token = 'tQiY2YhT3IpTmhwOqZPNguT9WXrmt0yS6cUbMCVGFTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)