UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j1g7I7LE8okP4KTF+795wjkanMreuwUGvXF/ws5btbs='
WHERE
key_id = '6bbdd64ca49db17c484ee6d8a3d0b5f194266d616e07801115a6d09c50282a2b'
AND (
token = 'j1g7I7LE8okP4KTF+795wjkanMreuwUGvXF/ws5btbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)