UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRELIPYW/myJYMSaBumqRV8aozSrT+nQMv1g/sh33Qw='
WHERE
key_id = 'ab09a36ae895439a59cd10e6092f1a025a496b8e555d3094d73757a972f8c8f8'
AND (
token = 'pRELIPYW/myJYMSaBumqRV8aozSrT+nQMv1g/sh33Qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)