UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4VI/Xbe6p2MxS0EqWPgey5V9r0wARQGAzufDmXzOaU='
WHERE
key_id = 'bf378f1aa9e941daeee6767bdffbcabb40f84d5948e166992befedb0859c67ee'
AND (
token = 'z4VI/Xbe6p2MxS0EqWPgey5V9r0wARQGAzufDmXzOaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)