UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7OnOcn6LIOQYnCcJwphbkj0Zq9Ysdb427v8gnmwv6j8='
WHERE
key_id = 'b59ec7f7137e3f3423afd91894ebe05be3fa65600055a2c8af2708f7fb81144f'
AND (
token = '7OnOcn6LIOQYnCcJwphbkj0Zq9Ysdb427v8gnmwv6j8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)