UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fMoB5kpRiW+zVT53d1Gx/UpNx1BiyWTYej3bxktxEZ0='
WHERE
key_id = '7bfc60c98259e59ff26b798fff1b6b80d5ccd3f94cf5bb160543a013c045e314'
AND (
token = 'fMoB5kpRiW+zVT53d1Gx/UpNx1BiyWTYej3bxktxEZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)