UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLGamp7517skrMLP3LPrug/ZPS6u29o+0aFgsCO4o+0='
WHERE
key_id = 'a39a2d188e1cf4b6a93d1334b054f7b73028da5ed2fa7b7c78354b5f9834dd7a'
AND (
token = 'hLGamp7517skrMLP3LPrug/ZPS6u29o+0aFgsCO4o+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)