UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGu2sZOztMw0cEzJwMV60wC+TpGn/gqZ4nHHFjBhSIo='
WHERE
key_id = 'd867af49c49883d1c4dc6a97afb42a18d129f8e9a82feeb394aabe1ccfac48e0'
AND (
token = 'CGu2sZOztMw0cEzJwMV60wC+TpGn/gqZ4nHHFjBhSIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)