UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rIRHASMW/DW3f1j316/7p7CteuJ7XxgMKYLUD3xj8Kw='
WHERE
key_id = '8a38f165e0b8a0eac6dbd61dc32d1f3f15264d8429cbefda671d673ae1188871'
AND (
token = 'rIRHASMW/DW3f1j316/7p7CteuJ7XxgMKYLUD3xj8Kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)