UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IMcZTsAUqtdPoNkrnskrleFCndrTI4BDmhWHSmX/eAI='
WHERE
key_id = '4fd7b4d8dbcb1945d2a8bb98276019ef0e28d417b3e0d162f0c56d505d1f500c'
AND (
token = 'IMcZTsAUqtdPoNkrnskrleFCndrTI4BDmhWHSmX/eAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)