UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iiTX/EMWNuPoCuxpjVAaKALZoLsVYGv6z9+gmCiKxZ4='
WHERE
key_id = 'a7d49d25c67cf5d9dfbd5500f0760cc423b9b34b344081dcb1d80d8443b78ad5'
AND (
token = 'iiTX/EMWNuPoCuxpjVAaKALZoLsVYGv6z9+gmCiKxZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)