UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gC9zS+N16bFTzVmowG9nItrzlQXzsJJQHQMSm6iN4cg='
WHERE
key_id = '9b3c954d0e009bc3fa2698255f2db4bda764279653c38be22d730e815d0a1988'
AND (
token = 'gC9zS+N16bFTzVmowG9nItrzlQXzsJJQHQMSm6iN4cg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)