UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pi3gcADESst3TMWfS6AV3m7t4jifnkOcnxHvNsuVKvo='
WHERE
key_id = 'fbb9ec6636763ee57467a1ba3ea12c3fbf38e744931c8e485fdf1e84e1390031'
AND (
token = 'pi3gcADESst3TMWfS6AV3m7t4jifnkOcnxHvNsuVKvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)