UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZvfZBKbvP9fjALXrjKJzAi8UDwufVUSwCuA8D2RuLY='
WHERE
key_id = '7597b65adf4e090fa8ed4bf86f789fda7cfde8198d15b320f1700a5e5b5a7fe1'
AND (
token = 'PZvfZBKbvP9fjALXrjKJzAi8UDwufVUSwCuA8D2RuLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)