UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q3i9y1NiEduM6ILFUrASGKlOZRhwLE3l5kQHcIx6tgA='
WHERE
key_id = '9a301a4a2f2f28f6c62966de88f09e13e83d469a3e8da62ab1ba8d650ccaedf4'
AND (
token = 'Q3i9y1NiEduM6ILFUrASGKlOZRhwLE3l5kQHcIx6tgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)