UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9GmGGpEUmqKuABpc8I3UFCoLzokfuX7lxBW/3WRJh6s='
WHERE
key_id = '312a1486f9b667df4d66330f01fc10eb2c5e61eca1d788df5761b9ed642b8aa4'
AND (
token = '9GmGGpEUmqKuABpc8I3UFCoLzokfuX7lxBW/3WRJh6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)