UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZMNlx70bVeDSn+kXeJV0yUn29JZ0SwRov/k+tZ852oM='
WHERE
key_id = '18c7897dafad60faaf64061284d73ab63248e9ac6b5606e6639eccb5d8b3ff09'
AND (
token = 'ZMNlx70bVeDSn+kXeJV0yUn29JZ0SwRov/k+tZ852oM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)