UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiuV56WoedWxcnfD/K/7reFfABebfMMOPxVorz5x5Hc='
WHERE
key_id = '57a129d375d13dfdc6d3bca00fb2d4fa482ae46169e245d17bd033915da2f1a2'
AND (
token = 'ZiuV56WoedWxcnfD/K/7reFfABebfMMOPxVorz5x5Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)