UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'caFZ0MXE7K0RrvjcWk29CX1hX6tOzhXVkg7J6GfvVJU='
WHERE
key_id = '7ae3e2baa1909448af562d048f2bf712365d8abae61d742ec91534604e1a97cf'
AND (
token = 'caFZ0MXE7K0RrvjcWk29CX1hX6tOzhXVkg7J6GfvVJU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)